{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["6 дней без курицей"],"read":"whole","date_system":"1900"}

{"sheet":"6 дней без курицей","index":0,"n_rows":340,"n_cols":21,"rows_kept":340,"merged":[[0,0,0,1],[0,14,0,20],[1,0,1,6],[1,14,1,20],[2,0,2,6],[2,14,2,20],[4,0,4,20],[6,0,6,20],[34,0,34,20],[61,0,61,20],[89,0,89,20],[118,0,118,20],[145,0,145,20],[169,0,169,20],[195,0,195,20],[222,0,222,20],[249,0,249,20],[278,0,278,20],[306,0,306,20],[329,1,331,1],[329,2,329,4],[329,5,330,5],[329,6,329,10],[329,11,329,19],[336,2,336,19],[338,2,338,3],[338,4,338,5],[338,6,338,7],[338,8,338,9],[339,2,339,3],[339,4,339,5],[339,6,339,7],[339,8,339,9],[341,1,341,9]]}
["СОГЛАСОВАНО",{"$nulls":13},"УТВЕРЖДЕНО"]
["____________________________"]
["____________________________"]
[]
["Меню для организации питания детей от 1 до 7 лет, посещающих дошкольные образовательные учреждения Мензелинского района РТ на 2025г.(6 дней без курицы)"]
[]
["1 день, 1 неделя"]
[]
["№ рецептуры","Название блюда","Масса","Белки","Жиры","Углеводы","Энергетическая ценность","B1","B2","A","D","C","Na","K","Ca","Mg","P","Fe","I","Se","F"]
[null,null,"г","г","г","г","ккал","мг","мг","мкг рет.экв","мкг","мг","мг","мг","мг","мг","мг","мг","мкг","мкг","мкг"]
[null,"Понедельник, 1 неделя"]
[null,"Завтрак","1-7"]
["54-9к-2020","Каша вязкая молочная овсяная",180,7.7,10.1,30.9,245.6,0.19,0.16,36.18,0.12,0.47,311.99,246.64,141.88,56.55,210.04,1.65,46.13,13.11,56.05]
["54-4гн-2020","Чай с молоком и сахаром",150,1.1,0.8,6.4,37.7,0.01,0.05,5.06,0,0.21,14.52,53.29,75.98,6,32.05,0.31,3.38,0.66,7.5]
["Пром.","Батон простой",20,1.6,0.2,9.8,47.5,0.03,0.01,0,0,0,88.6,27.2,4.6,6.8,17.8,0.4,0.64,1.2,2.9]
[null,"Итого за Завтрак",{"$f":"SUM(C13:C15)","v":350},10.4,11.1,47.099999999999994,330.8,0.23,0.22000000000000003,41.24,0.12,0.6799999999999999,415.11,327.13,222.46,69.35,259.89,2.36,50.150000000000006,14.969999999999999,66.45]
[null,"Второй завтрак"]
["Пром.","Молоко 2.5%",150,4.4,3.8,7.2,80,0.06,0.23,33,0,1.95,75,219,180,21,135,0.15,13.5,3,30]
[null,"Итого за Второй завтрак",150,4.4,3.8,7.2,80,0.06,0.23,33,0,1.95,75,219,180,21,135,0.15,13.5,3,30]
[null,"Обед"]
["54-7з-2020","Салат из белокочанной капусты с растительным маслом",50,1.27,5.08,5.2,71.5,0.01,0.02,61.13,0,11,56,171,29,12,22,0.3,8.95,0.2,10.55]
["54-7с-2020","Суп картофельный с вермишелью",200,5.2,2.8,18.5,119.6,0.09,0.05,97.51,0,6.89,93.01,410.42,13.73,20.84,54.56,0.86,16.76,0.23,32.72]
["54-9м-2020 ","Жаркое по-домашнему",150,15,14.1,12.9,238.4,0.11,0.14,20.45,0.06,7.15,218.14,615.46,19.64,33.42,173.05,2.58,33.66,0.3,74.42]
["54-1хн-2020","Компот из смеси сухофруктов",150,0.4,0,14.8,60.7,0,0,11.25,0,0.02,0.04,0.13,81.06,1.58,3.23,0.06,0,0,0]
["Пром.","Хлеб пшеничный",20,1.5,0.2,9.8,46.9,0.02,0.01,0,0,0,99.8,18.6,4,2.8,13,0.22,0.64,1.2,2.9]
["Пром.","Хлеб ржаной",20,1.3,0.2,6.7,34.2,0.04,0.02,0,0,0,122,49,7,9.4,31.6,0.78,0,6.18,0]
[null,"Итого за Обед",{"$f":"SUM(C21:C26)","v":590},{"$f":"SUM(D21:D26)","v":24.669999999999998},22.38,67.9,571.3000000000001,0.26999999999999996,0.24000000000000002,190.34,0.06,25.06,588.99,1264.6100000000001,154.43,80.04,297.44000000000005,4.800000000000001,60.01,8.11,120.59]
[null,"Полдник"]
["54-3гн -2020","Кисель",150,0,0,9.5,37.9,0.03,0.03,9.37,0,1.59,0.09,1.18,43.75,0.1,0.08,0.02,0,0,0]
["Пром.","Сушка простая",15,1.6,0.2,10.3,49.6,0.03,0.01,0,0,0,90.75,27.75,4.5,6.9,18.15,0.44,0,0,0]
["Пром.","Фрукт (яблоко, банан, апельсин)",100,0.4,0.4,9.8,44.4,0.03,0.02,5,0,10,26,278,16,9,11,2.2,2,0.3,8]
[null,"Итого за Полдник",{"$f":"SUM(C29:C31)","v":265},{"$f":"SUM(D29:D31)","v":2},0.6000000000000001,29.6,131.9,0.09,0.06,14.37,0,11.59,116.84,306.93,64.25,16,29.229999999999997,2.66,2,0.3,8]
[null,"Итого за день",{"$f":"C16+C19+C27+C32","v":1355},{"$f":"D16+D19+D27+D32","v":41.47},37.88,151.8,1114.0000000000002,0.65,0.75,278.95000000000005,0.18,39.28,1195.9399999999998,2117.67,621.1400000000001,186.39,721.5600000000001,9.97,125.66,26.38,225.04000000000002]
[]
["2 день, 1 неделя"]
["№ рецептуры","Название блюда","Масса","Белки","Жиры","Углеводы","Энергетическая ценность","B1","B2","A","D","C","Na","K","Ca","Mg","P","Fe","I","Se","F"]
[null,null,"г","г","г","г","ккал","мг","мг","мкг рет.экв","мкг","мг","мг","мг","мг","мг","мг","мг","мкг","мкг","мкг"]
[null,"Вторник, 1 неделя"]
[null,"Завтрак","1-7"]
["54-1з-2020","Сыр твердых сортов в нарезке",10,2.3,3,0,35.8,0,0.03,26,0.1,0.07,81,8.8,88,3.5,50,0.1,0,1.45,0]
["54-6к-2020","Каша вязкая молочная пшенная",180,7.48,9.11,33.88,247.4,0.17,0.13,37.47,0.12,0,305,194,129,43,167,1.2,46.44,2.8,31.57]
["54-21гн-2020","Какао с молоком",150,2.6,1.9,8.3,60.8,0.02,0.09,9.94,0,0.39,28.76,119.2,107.24,17.45,71.55,0.51,6.75,1.32,20.51]
["Пром.","Батон простой",20,1.6,0.2,9.8,47.5,0.03,0.01,0,0,0,88.6,27.2,4.6,6.8,17.8,0.4,0.64,1.2,2.9]
[null,"Итого за Завтрак",{"$f":"SUM(C40:C43)","v":360},{"$f":"SUM(D40:D43)","v":13.98},14.209999999999999,51.980000000000004,391.5,0.22,0.26,73.41,0.22,0.46,503.36,349.2,328.84000000000003,70.75,306.35,2.21,53.83,6.7700000000000005,54.98]
[null,"Второй завтрак"]
["Пром.","Ряженка 2.5%",150,4.4,3.8,6.3,76.4,0.03,0.2,33,0,0.45,75,219,186,21,138,0.15,13.5,1.5,30]
[null,"Итого за Второй завтрак",{"$f":"C46","v":150},{"$f":"D46","v":4.4},3.8,6.3,76.4,0.03,0.2,33,0,0.45,75,219,186,21,138,0.15,13.5,1.5,30]
[null,"Обед"]
["54-13з-2020","Салат из свеклы отварной с растительным маслом",50,0.67,2.24,3.8,38.1,0.01,0.02,0.57,0,2,66,114,16,9,18,0.6,10,0.3,9.5]
["54-8с-2020","Суп гороховый",200,6.7,4.6,16.3,133.1,0.14,0.05,97.19,0,4.77,95.82,382.43,26.94,29,80.47,1.48,15.96,2.01,28.88]
["54-3м-2020 ","Голубцы ленивые",150,12.7,11.5,9.6,192.5,0.05,0.11,13.77,0.06,16.56,172.39,406.9,62.02,28.46,138.21,2.03,25.4,1.31,53.47]
["54-33хн-2020","Напиток апельсиновый",150,0.1,0,6,24.8,0,0,0.79,0,3.96,1.67,27.11,55.85,1.87,3.3,0.06,0.33,0.07,2.81]
["Пром.","Хлеб пшеничный",20,1.5,0.2,9.8,46.9,0.02,0.01,0,0,0,99.8,18.6,4,2.8,13,0.22,0.64,1.2,2.9]
["Пром.","Хлеб ржаной",20,1.3,0.2,6.7,34.2,0.04,0.02,0,0,0,122,49,7,9.4,31.6,0.78,0,6.18,0]
[null,"Итого за Обед",{"$f":"SUM(C49:C54)","v":590},{"$f":"SUM(D49:D54)","v":22.970000000000002},18.74,52.2,469.59999999999997,0.26,0.21,112.32,0.06,27.29,557.6800000000001,998.04,171.81,80.53000000000002,284.58000000000004,5.169999999999999,52.33,11.07,97.56]
[null,"Полдник"]
["54-10в-2020","Булочка ванильная",50,3.9,3.4,25.4,147.4,0.05,0.03,15.93,0.12,0,200.57,42.12,14.69,5.43,34.11,0.47,27.8,2.63,9.19]
["Пром.","Сок яблочный",160,0.8,0.16,16.16,69.3,0.01,0.01,0,0,1.28,7.3,159.36,9.86,5.57,9.74,1.95,0,0,0]
[null,"Итого за Полдник",{"$f":"SUM(C57:C58)","v":210},4.7,3.56,41.56,216.7,0.060000000000000005,0.04,15.93,0.12,1.28,207.87,201.48000000000002,24.549999999999997,11,43.85,2.42,27.8,2.63,9.19]
[null,"Итого за день",{"$f":"C44+C47+C55+C59","v":1310},46.05000000000001,40.31,152.04000000000002,1154.2,0.5700000000000001,0.7100000000000001,234.66,0.4,29.48,1343.9099999999999,1767.72,711.2,183.28000000000003,772.7800000000001,9.95,147.46,21.97,191.73]
[]
["3 день, 1 неделя"]
["№ рецептуры","Название блюда","Масса","Белки","Жиры","Углеводы","Энергетическая ценность","B1","B2","A","D","C","Na","K","Ca","Mg","P","Fe","I","Se","F"]
[null,null,"г","г","г","г","ккал","мг","мг","мкг рет.экв","мкг","мг","мг","мг","мг","мг","мг","мг","мкг","мкг","мкг"]
[null,"Среда, 1 неделя"]
[null,"Завтрак","1-7"]
["54-1о-2020","Омлет натуральный",150,12.68,17.95,3.25,225.2,0.07,0.4,182.66,2.18,0,264,180,110,17,202,2.1,43.65,26,62.62]
["54-3гн-2020","Чай с лимоном и сахаром",155,0.1,0,4.9,20.4,0,0,0.18,0,0.86,0.71,14.95,48.62,1.98,3.7,0.31,0.01,0.02,0.53]
["Пром.","Батон простой",20,1.6,0.2,9.8,47.5,0.03,0.01,0,0,0,88.6,27.2,4.6,6.8,17.8,0.4,0.64,1.2,2.9]
[null,"Итого за Завтрак",{"$f":"SUM(C67:C69)","v":325},{"$f":"SUM(D67:D69)","v":14.379999999999999},{"$f":"SUM(E67:E69)","v":18.15},{"$f":"SUM(F67:F69)","v":17.950000000000003},{"$f":"SUM(G67:G69)","v":293.1},{"$f":"SUM(H67:H69)","v":0.1},{"$f":"SUM(I67:I69)","v":0.41000000000000003},{"$f":"SUM(J67:J69)","v":182.84},{"$f":"SUM(K67:K69)","v":2.18},{"$f":"SUM(L67:L69)","v":0.86},{"$f":"SUM(M67:M69)","v":353.30999999999995},{"$f":"SUM(N67:N69)","v":222.14999999999998},{"$f":"SUM(O67:O69)","v":163.22},{"$f":"SUM(P67:P69)","v":25.78},{"$f":"SUM(Q67:Q69)","v":223.5},{"$f":"SUM(R67:R69)","v":2.81},{"$f":"SUM(S67:S69)","v":44.3},{"$f":"SUM(T67:T69)","v":27.22},{"$f":"SUM(U67:U69)","v":66.05}]
[null,"Второй завтрак"]
["Пром.","Молоко 2.5%",150,4.4,3.8,7.2,80,0.06,0.23,33,0,1.95,75,219,180,21,135,0.15,13.5,3,30]
[null,"Итого за Второй завтрак",150,4.4,3.8,7.2,80,0.06,0.23,33,0,1.95,75,219,180,21,135,0.15,13.5,3,30]
[null,"Обед"]
["54-16з-2020","Винегрет с растительным маслом",50,0.59,4.47,3.33,56,0.01,0.01,60.74,0,1,168,107,9,8,18,0.4,6.56,0,9.88]
["54-1с-2020","Щи из свежей капусты со сметаной",200,4.7,5.6,5.7,92.2,0.02,0.03,104.95,0,10.76,98.52,184,37.48,13.13,30.97,0.48,15.25,0.34,14.76]
["54-4г-2020","Каша гречневая рассыпчатая",130,7.1,5.5,31.1,202.5,0.19,0.1,16.63,0.08,0,129.52,190.11,40.4,104.13,156.86,3.51,19.31,3.05,13.92]
["ном.рец №174","Тефтели мясные из говядины полуфабрикат",75,8.98,9.49,7.31,150.5,0,0,0,0,0.79,0,0,0,0,0,0,0,0,0]
["54-3соус-2020","Соус красный основной",30,1,0.7,2.7,21.2,0.01,0,38.45,0.01,0.81,3.7,42.58,2.77,3.67,7.16,0.15,0.54,0.13,2.71]
["№438","Напиток яблочный",150,0.1,0.1,8.5,35.6,0,0,0,0,0.8,0,0,8.9,2.8,1.9,0.4,0,0,0]
["Пром.","Хлеб ржаной",20,1.3,0.2,6.7,34.2,0.04,0.02,0,0,0,122,49,7,9.4,31.6,0.78,0,6.18,0]
["Пром.","Хлеб пшеничный",20,1.5,0.2,9.8,46.9,0.02,0.01,0,0,0,99.8,18.6,4,2.8,13,0.22,0.64,1.2,2.9]
[null,"Итого за Обед",{"$f":"SUM(C75:C82)","v":675},{"$f":"SUM(D75:D82)","v":25.270000000000003},26.26,75.14,639.1,0.29000000000000004,0.17,220.76999999999998,0.09,14.160000000000002,621.54,591.2900000000001,109.55,143.93,259.49,5.94,42.3,10.899999999999999,44.17]
[null,"Полдник"]
["54-4гн-2020","Чай с молоком и сахаром",150,1.1,0.8,6.4,37.7,0.01,0.05,5.06,0,0.21,14.52,53.29,75.98,6,32.05,0.31,3.38,0.66,7.5]
["№ Т/К 401","Блин без начинки П/Ф (45гр) 1 шт",45,1.58,1.58,10.35,63,0,0,0,0,0,0,0,7.7,3.4,20.2,0.3,0,0,0]
[null,"Итого за Полдник",{"$f":"SUM(C85:C86)","v":195},2.68,2.38,16.75,100.7,0.01,0.05,5.06,0,0.21,14.52,53.29,83.68,9.4,52.25,0.61,3.38,0.66,7.5]
[null,"Итого за день",{"$f":"C70+C73+C83+C87","v":1345},46.730000000000004,50.59,117.04,1112.9,0.4600000000000001,0.8600000000000001,441.67,2.27,17.180000000000003,1064.37,1085.73,536.45,200.11,670.24,9.51,103.47999999999999,41.779999999999994,147.72]
[]
["4 день, 1 неделя"]
["№ рецептуры","Название блюда","Масса","Белки","Жиры","Углеводы","Энергетическая ценность","B1","B2","A","D","C","Na","K","Ca","Mg","P","Fe","I","Se","F"]
[null,null,"г","г","г","г","ккал","мг","мг","мкг рет.экв","мкг","мг","мг","мг","мг","мг","мг","мг","мкг","мкг","мкг"]
[null,"Четверг, 1 неделя"]
[null,"Завтрак","1-7"]
["54-1з-2020","Сыр твердых сортов в нарезке",10,2.3,3,0,35.8,0,0.03,26,0.1,0.07,81,8.8,88,3.5,50,0.1,0,1.45,0]
["54-7к-2020","Каша манная ",180,7.4,4.5,33.4,203.3,0.07,0.11,16.2,0,0.29,145.71,200.54,182.66,21.82,145.96,0.46,16.2,1.58,28.8]
["54-2гн-2020","Чай с сахаром",150,0.1,0,4.8,19.6,0,0,0.11,0,0.02,0.27,7.85,47.93,1.44,2.69,0.28,0,0,0]
["Пром.","Батон простой",20,1.6,0.2,9.8,47.5,0.03,0.01,0,0,0,88.6,27.2,4.6,6.8,17.8,0.4,0.64,1.2,2.9]
[null,"Итого за Завтрак",{"$f":"SUM(C95:C98)","v":360},{"$f":"SUM(D95:D98)","v":11.399999999999999},7.7,48,306.20000000000005,0.1,0.15000000000000002,42.31,0.1,0.38,315.58000000000004,244.39,323.19,33.56,216.45000000000002,1.2400000000000002,16.84,4.23,31.7]
[null,"Второй завтрак"]
["Пром.","Сок яблочный",160,0.8,0.16,16.16,69.3,0.01,0.01,0,0,1.28,7.3,159.36,9.86,5.57,9.74,1.95,0,0,0]
[null,"Итого за Второй завтрак",{"$f":"C101","v":160},{"$f":"D101","v":0.8},0.16,16.16,69.3,0.01,0.01,0,0,1.28,7.3,159.36,9.86,5.57,9.74,1.95,0,0,0]
[null,"Обед"]
["54-9з-2020","Салат из белокочанной капусты с морковью и яблоками и растительным маслом",50,0.68,5.08,3.01,60.5,0.01,0.02,120.81,0,5,56,111,17,8,14,0.4,8.23,0.1,9.15]
["54-7с-2020","Суп картофельный с вермишелью",200,5.2,2.8,18.5,119.6,0.09,0.05,97.51,0,6.89,93.01,410.42,13.73,20.84,54.56,0.86,16.76,0.23,32.72]
["54-21г-2020","Горошница",130,12.5,1.1,29.3,177.5,0.38,0.08,0.78,0,0,143.79,471.02,108.29,60.59,186.33,3.86,20.65,7.49,19.5]
["№272","Биточек рубленный из говядины с соусом","50/30",9.3,7.1,11.8,148.6,0,0,0.1,0,1.4,0,0,14.7,18.9,97,1.7,0,0,0]
["54-3гн -2020","Кисель",150,0,0,9.5,37.9,0.03,0.03,9.37,0,1.59,0.09,1.18,43.75,0.1,0.08,0.02,0,0,0]
["Пром.","Хлеб пшеничный",20,1.5,0.2,9.8,46.9,0.02,0.01,0,0,0,99.8,18.6,4,2.8,13,0.22,0.64,1.2,2.9]
["Пром.","Хлеб ржаной",20,1.3,0.2,6.7,34.2,0.04,0.02,0,0,0,122,49,7,9.4,31.6,0.78,0,6.18,0]
[null,"Итого за Обед",650,{"$f":"SUM(D104:D110)","v":30.48},16.479999999999997,88.61,625.2,0.5700000000000001,0.21000000000000002,228.57,0,14.88,514.6899999999999,1061.22,208.47,120.63000000000001,396.57,7.84,46.28,15.2,64.27]
[null,"Полдник"]
["54-21гн-2020","Какао с молоком",150,2.6,1.9,8.3,60.8,0.02,0.09,9.94,0,0.39,28.76,119.2,107.24,17.45,71.55,0.51,6.75,1.32,20.51]
["Пром.","Сушка простая",15,1.6,0.2,10.3,49.6,0.03,0.01,0,0,0,90.75,27.75,4.5,6.9,18.15,0.44,0,0,0]
["Пром.","Фрукт (яблоко, банан, апельсин)",140,0.4,0.4,9.8,44.4,0.03,0.02,5,0,10,26,278,16,9,11,2.2,2,0.3,8]
[null,"Итого за Полдник",{"$f":"SUM(C113:C115)","v":305},{"$f":"SUM(D113:D115)","v":4.6000000000000005},{"$f":"SUM(E113:E115)","v":2.5},28.400000000000002,154.8,0.08,0.12,14.94,0,10.39,145.51,424.95,127.74,33.35,100.69999999999999,3.1500000000000004,8.75,1.62,28.51]
[null,"Итого за день",{"$f":"C99+C102+C111+C116","v":1475},47.28,26.839999999999996,181.17,1155.5,0.76,0.49000000000000005,285.82,0.1,26.93,983.0799999999999,1889.92,669.26,193.11,723.46,14.180000000000001,71.87,21.05,124.48]
[]
["5 день, 1 неделя"]
["№ рецептуры","Название блюда","Масса","Белки","Жиры","Углеводы","Энергетическая ценность","B1","B2","A","D","C","Na","K","Ca","Mg","P","Fe","I","Se","F"]
[null,null,"г","г","г","г","ккал","мг","мг","мкг рет.экв","мкг","мг","мг","мг","мг","мг","мг","мг","мкг","мкг","мкг"]
[null,"Пятница, 1 неделя"]
[null,"Завтрак","1-7"]
["54-19к-2020","Суп молочный с макаронными изделиями",180,4.9,4.1,16.1,120.8,0.05,0.16,21.49,0.02,0.66,101.38,167.89,153.08,17.39,110.14,0.32,18.76,2.23,28.56]
["54-3гн-2020","Чай с лимоном и сахаром",155,0.1,0,4.9,20.4,0,0,0.18,0,0.86,0.71,14.95,48.62,1.98,3.7,0.31,0.01,0.02,0.53]
["Пром.","Батон простой",20,1.6,0.2,9.8,47.5,0.03,0.01,0,0,0,88.6,27.2,4.6,6.8,17.8,0.4,0.64,1.2,2.9]
[null,"Итого за Завтрак",{"$f":"SUM(C124:C126)","v":355},6.6,4.3,30.8,188.7,0.08,0.17,21.669999999999998,0.02,1.52,190.69,210.03999999999996,206.3,26.17,131.64000000000001,1.03,19.410000000000004,3.45,31.99]
[null,"Второй завтрак"]
["Пром.","Молоко 2.5%",150,4.4,3.8,7.2,80,0.06,0.23,33,0,1.95,75,219,180,21,135,0.15,13.5,3,30]
[null,"Итого за Второй завтрак",150,4.4,3.8,7.2,80,0.06,0.23,33,0,1.95,75,219,180,21,135,0.15,13.5,3,30]
[null,"Обед"]
["54-16з-2020","Винегрет с растительным маслом",50,0.59,4.47,3.33,56,0.01,0.01,60.74,0,1,168,107,9,8,18,0.4,6.56,0,9.88]
["54-2с-2020","Борщ с капустой и картофелем со сметаной",200,4.7,5.7,10.1,110.4,0.03,0.04,134.66,0,6.77,107.03,264.63,33.68,19.22,42.64,0.87,17.16,0.4,22.62]
["54-11г-2020","Картофельное пюре",130,2.7,4.6,17.2,120.8,0.1,0.09,20.62,0.08,8.84,140.21,541.52,34.22,24.47,73.21,0.89,24.67,0.68,37.09]
["54-7р-2020","Рыба, припущенная в молоке (минтай)",75,9.8,5.8,2.1,100,0.06,0.08,6.77,0.12,0.84,82.98,260.04,51.16,33.5,151.85,0.55,100.11,8.88,429.45]
["№438","Напиток яблочный",150,0.1,0.1,8.5,35.6,0,0,0,0,0.8,0,0,8.9,2.8,1.9,0.4,0,0,0]
["Пром.","Хлеб ржаной",20,1.3,0.2,6.7,34.2,0.04,0.02,0,0,0,122,49,7,9.4,31.6,0.78,0,6.18,0]
["Пром.","Хлеб пшеничный",20,1.5,0.2,9.8,46.9,0.02,0.01,0,0,0,99.8,18.6,4,2.8,13,0.22,0.64,1.2,2.9]
[null,"Итого за Обед",{"$f":"SUM(C132:C138)","v":645},{"$f":"SUM(D132:D138)","v":20.69},21.07,57.730000000000004,503.9,0.26,0.25,222.79000000000002,0.2,18.25,720.02,1240.79,147.96,100.19,332.2,4.109999999999999,149.14,17.34,501.93999999999994]
[null,"Полдник"]
["54-23гн-2020","Кофейный напиток с молоком",150,2.4,1.8,8.2,58.9,0.02,0.09,9.93,0,0.39,28.69,109.8,108.7,14.68,67.27,0.37,6.75,1.32,15]
["Пром.","Пряник",30,1.8,1.4,22.5,109.8,0.02,0.01,0,0,0,0.6,21.3,3.3,2.7,15,0.24,0,0,0]
[null,"Итого за Полдник",{"$f":"SUM(C141:C142)","v":180},4.2,3.2,30.7,168.7,0.04,0.09999999999999999,9.93,0,0.39,29.290000000000003,131.1,112,17.38,82.27,0.61,6.75,1.32,15]
[null,"Итого за день",{"$f":"C127+C130+C139+C143","v":1330},35.89,32.370000000000005,126.43,941.3,0.44,0.75,287.39000000000004,0.22,22.11,1015,1800.9299999999998,646.26,164.74,681.1099999999999,5.8999999999999995,188.79999999999998,25.11,578.93]
[]
["6 день, 1 неделя"]
["№ рецептуры","Название блюда","Масса","Белки","Жиры","Углеводы","Энергетическая ценность","B1","B2","A","D","C","Na","K","Ca","Mg","P","Fe","I","Se","F"]
[null,"Суббота, 1 неделя","г","г","г","г","ккал","мг","мг","мкг рет.экв","мкг","мг","мг","мг","мг","мг","мг","мг","мкг","мкг","мкг"]
[null,"Завтрак","1-7"]
["54-1т-2020                                     ","Запеканка из творога",150,29.7,10.7,22.3,304.2,0.06,0.32,51.24,0.16,0.29,188.79,159.57,224.07,32.46,290.8,0.86,29.82,39.13,49.65]
["54-2гн-2020","Чай - заварка",150,0.1,0,4.8,19.6,0,0,0.11,0,0.02,0.27,7.85,47.93,1.44,2.69,0.28,0,0,0]
["Пром.","молоко сгущенное с сахаром",20,1.4,1.7,11.1,65.5,0.01,0.08,9.4,0,0.2,26,73,61.4,6.8,43.8,0.04,1.4,0.6,7]
["Пром.","Батон простой",20,1.6,0.2,9.8,47.5,0.03,0.01,0,0,0,88.6,27.2,4.6,6.8,17.8,0.4,0.64,1.2,2.9]
[null,"Итого за Завтрак",{"$f":"SUM(C150:C153)","v":340},{"$f":"SUM(D150:D153)","v":32.8},{"$f":"SUM(E150:E153)","v":12.599999999999998},{"$f":"SUM(F150:F153)","v":48},{"$f":"SUM(G150:G153)","v":436.8},{"$f":"SUM(H150:H153)","v":0.09999999999999999},{"$f":"SUM(I150:I153)","v":0.41000000000000003},{"$f":"SUM(J150:J153)","v":60.75},{"$f":"SUM(K150:K153)","v":0.16},{"$f":"SUM(L150:L153)","v":0.51},{"$f":"SUM(M150:M153)","v":303.65999999999997},{"$f":"SUM(N150:N153)","v":267.62},{"$f":"SUM(O150:O153)","v":338},{"$f":"SUM(P150:P153)","v":47.49999999999999},{"$f":"SUM(Q150:Q153)","v":355.09000000000003},{"$f":"SUM(R150:R153)","v":1.58},{"$f":"SUM(S150:S153)","v":31.86},{"$f":"SUM(T150:T153)","v":40.93000000000001},{"$f":"SUM(U150:U153)","v":59.55}]
[null,"Второй завтрак"]
["Пром.","Сок яблочный",160,0.8,0.16,16.16,69.3,0.01,0.01,0,0,1.28,7.3,159.36,9.86,5.57,9.74,1.95,0,0,0]
[null,"Итого за Второй завтрак",{"$f":"C156","v":160},{"$f":"D156","v":0.8},0.16,16.16,69.3,0.01,0.01,0,0,1.28,7.3,159.36,9.86,5.57,9.74,1.95,0,0,0]
[null,"Обед"]
["54-11з-2020","Салат из моркови с яблоками и растительным маслом",50,0.46,5.09,3.57,62,0.01,0.02,366.45,0,2,57,86,10,11,16,0.5,8.5,0,17.98]
["54-1с-2020","Щи из свежей капусты со сметаной",200,4.7,5.6,5.7,92.2,0.02,0.03,104.95,0,10.76,98.52,184,37.48,13.13,30.97,0.48,15.25,0.34,14.76]
["54-1г-2020","Макароны отварные",130,4.6,4.3,28.4,170.6,0.05,0.02,15.91,0.08,0,129.16,46.62,91.72,6.24,35.28,0.64,18,0.05,10.33]
["№272","Биточек рубленный из говядины с соусом","50/30",9.3,7.1,11.8,148.6,0,0,0.1,0,1.4,0,0,14.7,18.9,97,1.7,0,0,0]
["54-33хн-2020","Напиток апельсиновый",150,0.1,0,6,24.8,0,0,0.79,0,3.96,1.67,27.11,55.85,1.87,3.3,0.06,0.33,0.07,2.81]
["Пром.","Хлеб ржаной",20,1.3,0.2,6.7,34.2,0.04,0.02,0,0,0,122,49,7,9.4,31.6,0.78,0,6.18,0]
[null,"Итого за Обед",630,{"$f":"SUM(D159:D164)","v":20.460000000000004},{"$f":"SUM(E159:E164)","v":22.289999999999996},{"$f":"SUM(F159:F164)","v":62.17},{"$f":"SUM(G159:G164)","v":532.4},{"$f":"SUM(H159:H164)","v":0.12},{"$f":"SUM(I159:I164)","v":0.09000000000000001},{"$f":"SUM(J159:J164)","v":488.20000000000005},{"$f":"SUM(K159:K164)","v":0.08},{"$f":"SUM(L159:L164)","v":18.12},{"$f":"SUM(M159:M164)","v":408.34999999999997},{"$f":"SUM(N159:N164)","v":392.73},{"$f":"SUM(O159:O164)","v":216.74999999999997},{"$f":"SUM(P159:P164)","v":60.54},{"$f":"SUM(Q159:Q164)","v":214.15},{"$f":"SUM(R159:R164)","v":4.16},{"$f":"SUM(S159:S164)","v":42.08},{"$f":"SUM(T159:T164)","v":6.64},{"$f":"SUM(U159:U164)","v":45.88}]
[]
[]
[null,"Итого за день",{"$f":"C165+C157+C154","v":1130},{"$f":"D165+D157+D154","v":54.06},{"$f":"E165+E157+E154","v":35.05},{"$f":"F165+F157+F154","v":126.33},{"$f":"G165+G157+G154","v":1038.5},{"$f":"H165+H157+H154","v":0.22999999999999998},{"$f":"I165+I157+I154","v":0.51},{"$f":"J165+J157+J154","v":548.95},{"$f":"K165+K157+K154","v":0.24},{"$f":"L165+L157+L154","v":19.910000000000004},{"$f":"M165+M157+M154","v":719.31},{"$f":"N165+N157+N154","v":819.71},{"$f":"O165+O157+O154","v":564.6099999999999},{"$f":"P165+P157+P154","v":113.60999999999999},{"$f":"Q165+Q157+Q154","v":578.98},{"$f":"R165+R157+R154","v":7.69},{"$f":"S165+S157+S154","v":73.94},{"$f":"T165+T157+T154","v":47.57000000000001},{"$f":"U165+U157+U154","v":105.43}]
[]
["7 день, 2 неделя"]
["№ рецептуры","Название блюда","Масса","Белки","Жиры","Углеводы","Энергетическая ценность","B1","B2","A","D","C","Na","K","Ca","Mg","P","Fe","I","Se","F"]
[null,null,"г","г","г","г","ккал","мг","мг","мкг рет.экв","мкг","мг","мг","мг","мг","мг","мг","мг","мкг","мкг","мкг"]
[null,"Понедельник, 2 неделя"]
[null,"Завтрак","1-7"]
["54-3г-2020","Макароны отварные с сыром",180,9.5,8.2,34.4,249.3,0.07,0.06,40.39,0.23,0.05,289.07,68.97,187.54,13.05,120.39,0.92,24.8,2.34,12.44]
["54-21гн-2020","Какао с молоком",150,2.6,1.9,8.3,60.8,0.02,0.09,9.94,0,0.39,28.76,119.2,107.24,17.45,71.55,0.51,6.75,1.32,20.51]
["Пром.","Батон простой",20,1.6,0.2,9.8,47.5,0.03,0.01,0,0,0,88.6,27.2,4.6,6.8,17.8,0.4,0.64,1.2,2.9]
[null,"Итого за Завтрак",{"$f":"SUM(C175:C177)","v":350},{"$f":"SUM(D175:D177)","v":13.7},{"$f":"SUM(E175:E177)","v":10.299999999999999},{"$f":"SUM(F175:F177)","v":52.5},{"$f":"SUM(G175:G177)","v":357.6},{"$f":"SUM(H175:H177)","v":0.12000000000000001},{"$f":"SUM(I175:I177)","v":0.16},{"$f":"SUM(J175:J177)","v":50.33},{"$f":"SUM(K175:K177)","v":0.23},{"$f":"SUM(L175:L177)","v":0.44},{"$f":"SUM(M175:M177)","v":406.42999999999995},{"$f":"SUM(N175:N177)","v":215.37},{"$f":"SUM(O175:O177)","v":299.38},{"$f":"SUM(P175:P177)","v":37.3},{"$f":"SUM(Q175:Q177)","v":209.74},{"$f":"SUM(R175:R177)","v":1.83},{"$f":"SUM(S175:S177)","v":32.19},{"$f":"SUM(T175:T177)","v":4.86},{"$f":"SUM(U175:U177)","v":35.85}]
[null,"Второй завтрак"]
["Пром.","Сок яблочный",160,0.8,0.16,16.16,69.3,0.01,0.01,0,0,1.28,7.3,159.36,9.86,5.57,9.74,1.95,0,0,0]
[null,"Итого за Второй завтрак",{"$f":"C180","v":160},{"$f":"D180","v":0.8},0.16,16.16,69.3,0.01,0.01,0,0,1.28,7.3,159.36,9.86,5.57,9.74,1.95,0,0,0]
[null,"Обед"]
["54-13з-2020","Салат из свеклы отварной с растительным маслом",50,0.67,2.24,3.8,38.1,0.01,0.02,0.57,0,2,66,114,16,9,18,0.6,10,0.3,9.5]
["54-3с-2020","Рассольник Ленинградский",200,4.8,5.8,13.6,125.5,0.06,0.05,103.93,0,5.54,196.79,334.95,21.08,19.71,51.39,0.71,16.6,0.75,28.28]
["54-13м-2020","Запеканка картофельная с говядиной",150,17.7,18,19.8,312.2,0.15,0.19,36.29,0.14,9.9,279.43,818.72,22.83,42.22,209,3.1,42.84,1.67,91.91]
["54-1хн-2020","Компот из смеси сухофруктов",150,0.4,0,14.8,60.7,0,0,11.25,0,0.02,0.04,0.13,81.06,1.58,3.23,0.06,0,0,0]
["Пром.","Хлеб пшеничный",20,1.5,0.2,9.8,46.9,0.02,0.01,0,0,0,99.8,18.6,4,2.8,13,0.22,0.64,1.2,2.9]
["Пром.","Хлеб ржаной",20,1.3,0.2,6.7,34.2,0.04,0.02,0,0,0,122,49,7,9.4,31.6,0.78,0,6.18,0]
[null,"Итого за Обед",{"$f":"SUM(C183:C188)","v":590},{"$f":"SUM(D183:D188)","v":26.369999999999997},26.439999999999998,68.5,617.6,0.27999999999999997,0.29000000000000004,152.04,0.14,17.46,764.06,1335.4,151.97,84.71000000000001,326.22,5.47,70.08,10.1,132.59]
[null,"Полдник"]
["54-2гн-2020","Чай с сахаром",150,0.1,0,4.8,19.6,0,0,0.11,0,0.02,0.27,7.85,47.93,1.44,2.69,0.28,0,0,0]
["54-10в-2020","Булочка ванильная",50,3.9,3.4,25.4,147.4,0.05,0.03,15.93,0.12,0,200.57,42.12,14.69,5.43,34.11,0.47,27.8,2.63,9.19]
[null,"Итого за Полдник",{"$f":"SUM(C191:C192)","v":200},4,3.4,30.2,167,0.05,0.03,16.04,0.12,0.02,200.84,49.97,62.62,6.869999999999999,36.8,0.75,27.8,2.63,9.19]
[null,"Итого за день",{"$f":"C178+C181+C189+C193","v":1300},44.87,40.3,167.35999999999999,1211.5,0.45999999999999996,0.4900000000000001,218.41,0.49,19.2,1378.6299999999999,1760.1000000000001,523.83,134.45000000000002,582.5,10,130.07,17.59,177.63]
[]
["8 день, 2 неделя"]
["№ рецептуры","Название блюда","Масса","Белки","Жиры","Углеводы","Энергетическая ценность","B1","B2","A","D","C","Na","K","Ca","Mg","P","Fe","I","Se","F"]
[null,null,"г","г","г","г","ккал","мг","мг","мкг рет.экв","мкг","мг","мг","мг","мг","мг","мг","мг","мкг","мкг","мкг"]
[null,"Вторник, 2 неделя"]
[null,"Завтрак","1-7"]
["54-1т-2020","Запеканка из творога ",150,29.66,12.58,21.65,301.2,0.06,0.3,51.11,0.16,0,181,159,223,32,291,0.8,28.82,39,49.63]
["Пром.","Молоко сгущенное с сахаром",20,1.44,1.7,11.1,65.5,0.01,0.06,5.64,0,0,20,61,54,6,38,0,1.4,0.5,7]
["54-4гн-2020","Чай с молоком и сахаром",150,1.1,0.8,6.4,37.7,0.01,0.05,5.06,0,0.21,14.52,53.29,75.98,6,32.05,0.31,3.38,0.66,7.5]
["Пром.","Батон простой",20,1.6,0.2,9.8,47.5,0.03,0.01,0,0,0,88.6,27.2,4.6,6.8,17.8,0.4,0.64,1.2,2.9]
[null,"Итого за Завтрак",{"$f":"SUM(C201:C204)","v":340},33.800000000000004,15.28,48.95,451.9,0.10999999999999999,0.42,61.81,0.16,0.21,304.12,300.49,357.58000000000004,50.8,378.85,1.5100000000000002,34.24,41.36,67.03]
[null,"Второй завтрак"]
["Пром.","Молоко 2.5%",150,4.4,3.8,7.2,80,0.06,0.23,33,0,1.95,75,219,180,21,135,0.15,13.5,3,30]
[null,"Итого за Второй завтрак",150,4.4,3.8,7.2,80,0.06,0.23,33,0,1.95,75,219,180,21,135,0.15,13.5,3,30]
[null,"Обед"]
["54-9з-2020","Салат из белокочанной капусты с морковью и яблоками и растительным маслом",50,0.68,5.08,3.01,60.5,0.01,0.02,120.81,0,5,56,111,17,8,14,0.4,8.23,0.1,9.15]
["54-6с-2020","Суп картофельный с клецками",200,4.6,3.3,11.4,93.6,0.05,0.04,101.43,0.05,3.69,58.01,222.12,13.28,12.74,35.97,0.54,10.28,0.94,21.22]
["54-11м-2020","Плов из говядины","120/30",11.5,11.1,29,261.6,0.05,0.09,196.2,0.08,0.59,207.54,202.26,87.76,33,145.5,1.66,29.04,5.52,61.67]
["54-33хн-2020","Напиток апельсиновый",150,0.1,0,6,24.8,0,0,0.79,0,3.96,1.67,27.11,55.85,1.87,3.3,0.06,0.33,0.07,2.81]
["Пром.","Хлеб пшеничный",20,1.5,0.2,9.8,46.9,0.02,0.01,0,0,0,99.8,18.6,4,2.8,13,0.22,0.64,1.2,2.9]
["Пром.","Хлеб ржаной",20,1.3,0.2,6.7,34.2,0.04,0.02,0,0,0,122,49,7,9.4,31.6,0.78,0,6.18,0]
[null,"Итого за Обед",600,{"$f":"SUM(D210:D215)","v":19.680000000000003},{"$f":"SUM(E210:E215)","v":19.879999999999995},65.91,521.6,0.17,0.18,419.23,0.13,13.239999999999998,545.02,630.09,184.89000000000001,67.81,243.37,3.66,48.519999999999996,14.01,97.75]
[null,"Полдник"]
["54-3гн-2020","Чай с лимоном и сахаром",155,0.2,0,5,20.9,0,0.01,0.29,0,0.87,0.95,22.67,50.25,3.42,6.39,0.58,0.01,0.02,0.53]
["Пром.","Пряник",30,1.8,1.4,22.5,109.8,0.02,0.01,0,0,0,0.6,21.3,3.3,2.7,15,0.24,0,0,0]
[null,"Итого за Полдник",{"$f":"SUM(C218:C219)","v":185},{"$f":"SUM(D218:D219)","v":2},{"$f":"SUM(E218:E219)","v":1.4},{"$f":"SUM(F218:F219)","v":27.5},{"$f":"SUM(G218:G219)","v":130.7},{"$f":"SUM(H218:H219)","v":0.02},{"$f":"SUM(I218:I219)","v":0.02},{"$f":"SUM(J218:J219)","v":0.29},{"$f":"SUM(K218:K219)","v":0},{"$f":"SUM(L218:L219)","v":0.87},{"$f":"SUM(M218:M219)","v":1.5499999999999998},{"$f":"SUM(N218:N219)","v":43.97},{"$f":"SUM(O218:O219)","v":53.55},{"$f":"SUM(P218:P219)","v":6.12},{"$f":"SUM(Q218:Q219)","v":21.39},{"$f":"SUM(R218:R219)","v":0.82},{"$f":"SUM(S218:S219)","v":0.01},{"$f":"SUM(T218:T219)","v":0.02},{"$f":"SUM(U218:U219)","v":0.53}]
[null,"Итого за день",{"$f":"C205+C208+C216+C220","v":1275},{"$f":"D205+D208+D216+D220","v":59.88000000000001},{"$f":"E205+E208+E216+E220","v":40.35999999999999},{"$f":"F205+F208+F216+F220","v":149.56},{"$f":"G205+G208+G216+G220","v":1184.2},{"$f":"H205+H208+H216+H220","v":0.36},{"$f":"I205+I208+I216+I220","v":0.8500000000000001},{"$f":"J205+J208+J216+J220","v":514.3299999999999},{"$f":"K205+K208+K216+K220","v":0.29000000000000004},{"$f":"L205+L208+L216+L220","v":16.27},{"$f":"M205+M208+M216+M220","v":925.6899999999999},{"$f":"N205+N208+N216+N220","v":1193.55},{"$f":"O205+O208+O216+O220","v":776.02},{"$f":"P205+P208+P216+P220","v":145.73000000000002},{"$f":"Q205+Q208+Q216+Q220","v":778.61},{"$f":"R205+R208+R216+R220","v":6.140000000000001},{"$f":"S205+S208+S216+S220","v":96.27},{"$f":"T205+T208+T216+T220","v":58.39},{"$f":"U205+U208+U216+U220","v":195.31}]
[]
["9 день, 2 неделя"]
["№ рецептуры","Название блюда","Масса","Белки","Жиры","Углеводы","Энергетическая ценность","B1","B2","A","D","C","Na","K","Ca","Mg","P","Fe","I","Se","F"]
[null,null,"г","г","г","г","ккал","мг","мг","мкг рет.экв","мкг","мг","мг","мг","мг","мг","мг","мг","мкг","мкг","мкг"]
[null,"Среда, 2 неделя"]
[null,"Завтрак","1-7"]
["54-19к-2020","Суп молочный с макаронными изделиями",180,4.9,4.1,16.1,120.8,0.05,0.16,21.49,0.02,0.66,101.38,167.89,153.08,17.39,110.14,0.32,18.76,2.23,28.56]
["54-23гн-2020","Кофейный напиток с молоком",150,2.4,1.8,8.2,58.9,0.02,0.09,9.93,0,0.39,28.69,109.8,108.7,14.68,67.27,0.37,6.75,1.32,15]
["Пром.","Батон простой",20,1.6,0.2,9.8,47.5,0.03,0.01,0,0,0,88.6,27.2,4.6,6.8,17.8,0.4,0.64,1.2,2.9]
[null,"Итого за Завтрак",{"$f":"SUM(C228:C230)","v":350},8.9,6.1,34.1,227.2,0.1,0.26,31.419999999999998,0.02,1.05,218.67,304.89,266.38000000000005,38.87,195.21,1.0899999999999999,26.150000000000002,4.75,46.46]
[null,"Второй завтрак"]
["Пром.","Ряженка 2.5%",150,4.4,3.8,6.3,76.4,0.03,0.2,33,0,0.45,75,219,186,21,138,0.15,13.5,1.5,30]
[null,"Итого за Второй завтрак",{"$f":"C233","v":150},{"$f":"D233","v":4.4},3.8,6.3,76.4,0.03,0.2,33,0,0.45,75,219,186,21,138,0.15,13.5,1.5,30]
[null,"Обед"]
["54-13з-2020","Салат из свеклы отварной с растительным маслом",50,0.67,2.24,3.8,38.1,0.01,0.02,0.57,0,2,66,114,16,9,18,0.6,10,0.3,9.5]
["54-8с-2020","Суп гороховый",200,6.7,4.6,16.3,133.1,0.14,0.05,97.19,0,4.77,95.82,382.43,26.94,29,80.47,1.48,15.96,2.01,28.88]
["54-4г-2020","Каша гречневая рассыпчатая",130,7.1,5.5,31.1,202.5,0.19,0.1,16.63,0.08,0,129.52,190.11,40.4,104.13,156.86,3.51,19.31,3.05,13.92]
["54-2м-2020 ","Гуляш из говядины","40/40",13.6,13.2,3.1,185.7,0.04,0.1,20.37,0.06,1.13,96.78,257.95,44.59,18.6,133.3,1.97,13.64,0.26,50.17]
["54-3гн -2020","Кисель ",150,0,0,9.5,37.9,0.03,0.03,9.37,0,1.59,0.09,1.18,43.75,0.1,0.08,0.02,0,0,0]
["Пром.","Хлеб ржаной",20,1.3,0.2,6.7,34.2,0.04,0.02,0,0,0,122,49,7,9.4,31.6,0.78,0,6.18,0]
["Пром.","Хлеб пшеничный",20,1.5,0.2,9.8,46.9,0.02,0.01,0,0,0,99.8,18.6,4,2.8,13,0.22,0.64,1.2,2.9]
[null,"Итого за Обед",660,{"$f":"SUM(D236:D242)","v":30.87},{"$f":"SUM(E236:E242)","v":25.939999999999998},80.3,678.4,0.47000000000000003,0.33000000000000007,144.13,0.14,9.49,610.01,1013.27,182.68,173.03,433.31,8.58,59.55,12.999999999999998,105.37]
[null,"Полдник"]
["54-10в-2020","Булочка ванильная",50,3.9,3.4,25.4,147.4,0.05,0.03,15.93,0.12,0,200.57,42.12,14.69,5.43,34.11,0.47,27.8,2.63,9.19]
["№438","Напиток яблочный",150,0.1,0.1,8.5,35.6,0,0,0,0,0.8,0,0,8.9,2.8,1.9,0.4,0,0,0]
[null,"Итого за Полдник",{"$f":"SUM(C245:C246)","v":200},4,3.5,33.9,183,0.05,0.03,15.93,0.12,0.8,200.57,42.12,23.59,8.23,36.01,0.87,27.8,2.63,9.19]
[null,"Итого за день",{"$f":"C231+C234+C243+C247","v":1360},48.17,39.339999999999996,154.6,1165,0.6500000000000001,0.8200000000000001,224.48000000000002,0.28,11.790000000000001,1104.25,1579.2799999999997,658.6500000000001,241.13,802.53,10.69,127,21.88,191.02]
[]
["10 день, 2 неделя"]
["№ рецептуры","Название блюда","Масса","Белки","Жиры","Углеводы","Энергетическая ценность","B1","B2","A","D","C","Na","K","Ca","Mg","P","Fe","I","Se","F"]
[null,null,"г","г","г","г","ккал","мг","мг","мкг рет.экв","мкг","мг","мг","мг","мг","мг","мг","мг","мкг","мкг","мкг"]
[null,"Четверг, 2 неделя"]
[null,"Завтрак","1-7"]
["54-1з-2020","Сыр твердых сортов в нарезке",10,2.3,3,0,35.8,0,0.03,26,0.1,0.07,81,8.8,88,3.5,50,0.1,0,1.45,0]
["54-18к-2020","Суп молочный с рисом",180,4.4,4,16.5,120.1,0.04,0.16,21.49,0.02,0.66,102.36,165.14,151.69,21.65,118.04,0.25,18.74,4.15,32.45]
["54-2гн-2020","Чай с сахаром",150,0.1,0,4.8,19.6,0,0,0.11,0,0.02,0.27,7.85,47.93,1.44,2.69,0.28,0,0,0]
["Пром.","Батон простой",20,1.6,0.2,9.8,47.5,0.03,0.01,0,0,0,88.6,27.2,4.6,6.8,17.8,0.4,0.64,1.2,2.9]
[null,"Итого за Завтрак",{"$f":"SUM(C255:C258)","v":360},{"$f":"SUM(D255:D258)","v":8.4},{"$f":"SUM(E255:E258)","v":7.2},{"$f":"SUM(F255:F258)","v":31.1},{"$f":"SUM(G255:G258)","v":222.99999999999997},{"$f":"SUM(H255:H258)","v":0.07},{"$f":"SUM(I255:I258)","v":0.2},{"$f":"SUM(J255:J258)","v":47.599999999999994},{"$f":"SUM(K255:K258)","v":0.12000000000000001},{"$f":"SUM(L255:L258)","v":0.75},{"$f":"SUM(M255:M258)","v":272.23},{"$f":"SUM(N255:N258)","v":208.98999999999998},{"$f":"SUM(O255:O258)","v":292.22},{"$f":"SUM(P255:P258)","v":33.39},{"$f":"SUM(Q255:Q258)","v":188.53000000000003},{"$f":"SUM(R255:R258)","v":1.03},{"$f":"SUM(S255:S258)","v":19.38},{"$f":"SUM(T255:T258)","v":6.800000000000001},{"$f":"SUM(U255:U258)","v":35.35}]
[null,"Второй завтрак"]
["Пром.","Молоко 2.5%",150,4.4,3.8,7.2,80,0.06,0.23,33,0,1.95,75,219,180,21,135,0.15,13.5,3,30]
[null,"Итого за Второй завтрак",150,4.4,3.8,7.2,80,0.06,0.23,33,0,1.95,75,219,180,21,135,0.15,13.5,3,30]
[null,"Обед"]
["54-7з-2020","Салат из белокочанной капусты с растительным маслом",50,1.27,5.08,5.2,71.5,0.01,0.02,61.13,0,11,56,171,29,12,22,0.3,8.95,0.2,10.55]
["54-7с-2020","Суп картофельный с вермишелью",200,5.2,2.8,18.5,119.6,0.09,0.05,97.51,0,6.89,93.01,410.42,13.73,20.84,54.56,0.86,16.76,0.23,32.72]
["54-11г-2020","Картофельное пюре",130,2.7,4.6,17.2,120.8,0.1,0.09,20.62,0.08,8.84,140.21,541.52,34.22,24.47,73.21,0.89,24.67,0.68,37.09]
["№272","Биточек рубленный из говядины с соусом","50/30",9.3,7.1,11.8,148.6,0,0,0.1,0,1.4,0,0,14.7,18.9,97,1.7,0,0,0]
["54-1хн-2020","Компот из смеси сухофруктов",150,0.4,0,14.8,60.7,0,0,11.25,0,0.02,0.04,0.13,81.06,1.58,3.23,0.06,0,0,0]
["Пром.","Хлеб пшеничный",20,1.5,0.2,9.8,46.9,0.02,0.01,0,0,0,99.8,18.6,4,2.8,13,0.22,0.64,1.2,2.9]
["Пром.","Хлеб ржаной",20,1.3,0.2,6.7,34.2,0.04,0.02,0,0,0,122,49,7,9.4,31.6,0.78,0,6.18,0]
[null,"Итого за Обед",650,{"$f":"SUM(D264:D270)","v":21.67},19.979999999999997,84,602.3000000000001,0.26,0.19,190.61,0.08,28.15,511.06000000000006,1190.67,183.71,89.99000000000001,294.6,4.8100000000000005,51.02,8.49,83.26]
[null,"Полдник"]
["54-4гн-2020","Чай с молоком и сахаром",150,1.1,0.8,6.4,37.7,0.01,0.05,5.06,0,0.21,14.52,53.29,75.98,6,32.05,0.31,3.38,0.66,7.5]
["Пром.","Фрукт (яблоко, банан, апельсин)",130,3.6,1.2,50.4,226.8,0.07,0.1,28.8,0,10,57,693,17,88,58,1.3,0.12,2.1,5.28]
["Пром.","Сушка простая",15,1.6,0.2,10.3,49.6,0.03,0.01,0,0,0,90.75,27.75,4.5,6.9,18.15,0.44,0,0,0]
[null,"Итого за Полдник",{"$f":"SUM(C273:C275)","v":295},6.300000000000001,2.2,67.1,314.1,0.11,0.16000000000000003,33.86,0,10.21,162.26999999999998,774.04,97.48,100.9,108.19999999999999,2.0500000000000003,3.5,2.7600000000000002,12.780000000000001]
[null,"Итого за день",{"$f":"C259+C262+C271+C276","v":1455},40.769999999999996,33.18,189.4,1219.4,0.5,0.7800000000000001,305.07000000000005,0.2,41.06,1020.5600000000001,2392.7,753.4100000000001,245.28,726.3300000000002,8.040000000000001,87.4,21.05,161.39000000000001]
[]
["11 день, 2 неделя"]
["№ рецептуры","Название блюда","Масса","Белки","Жиры","Углеводы","Энергетическая ценность","B1","B2","A","D","C","Na","K","Ca","Mg","P","Fe","I","Se","F"]
[null,null,"г","г","г","г","ккал","мг","мг","мкг рет.экв","мкг","мг","мг","мг","мг","мг","мг","мг","мкг","мкг","мкг"]
[null,"Пятница, 2 неделя"]
[null,"Завтрак","1-7"]
["54-1о-2020","Омлет натуральный",150,12.68,17.95,3.25,225.2,0.07,0.4,182.66,2.18,0,264,180,110,17,202,2.1,43.65,26,62.62]
["54-3гн-2020","Чай с лимоном и сахаром",155,0.1,0,4.9,20.4,0,0,0.18,0,0.86,0.71,14.95,48.62,1.98,3.7,0.31,0.01,0.02,0.53]
["Пром.","Батон простой",20,1.6,0.2,9.8,47.5,0.03,0.01,0,0,0,88.6,27.2,4.6,6.8,17.8,0.4,0.64,1.2,2.9]
[null,"Итого за Завтрак",{"$f":"SUM(C284:C286)","v":325},14.379999999999999,18.15,17.950000000000003,293.1,0.1,0.41000000000000003,182.84,2.18,0.86,353.30999999999995,222.14999999999998,163.22,25.78,223.5,2.81,44.3,27.22,66.05]
[null,"Второй завтрак"]
["Пром.","Ряженка 2.5%",150,4.4,3.8,6.3,76.4,0.03,0.2,33,0,0.45,75,219,186,21,138,0.15,13.5,1.5,30]
[null,"Итого за Второй завтрак",{"$f":"C289","v":150},{"$f":"D289","v":4.4},3.8,6.3,76.4,0.03,0.2,33,0,0.45,75,219,186,21,138,0.15,13.5,1.5,30]
[null,"Обед"]
["54-16з-2020","Винегрет с растительным маслом",50,0.59,4.47,3.33,56,0.01,0.01,60.74,0,1,168,107,9,8,18,0.4,6.56,0,9.88]
["54-2с-2020","Борщ с капустой и картофелем со сметаной",200,4.7,5.7,10.1,110.4,0.03,0.04,134.66,0,6.77,107.03,264.63,33.68,19.22,42.64,0.87,17.16,0.4,22.62]
["54-1г-2020","Макароны отварные",130,4.6,4.3,28.4,170.6,0.05,0.02,15.91,0.08,0,129.16,46.62,91.72,6.24,35.28,0.64,18,0.05,10.33]
["ном.рец №174","Тефтели мясные из говядины, полуфабрикат",75,8.98,9.49,7.31,150.5,0,0,0,0,0.79,0,0,0,0,0,0,0,0,0]
["54-3соус-2020","Соус красный основной",30,1,0.7,2.7,21.2,0.01,0,38.45,0.01,0.81,3.7,42.58,2.77,3.67,7.16,0.15,0.54,0.13,2.71]
["№438","Напиток яблочный",150,0.1,0.1,8.5,35.6,0,0,0,0,0.8,0,0,8.9,2.8,1.9,0.4,0,0,0]
["Пром.","Хлеб пшеничный",20,1.5,0.2,9.8,46.9,0.02,0.01,0,0,0,99.8,18.6,4,2.8,13,0.22,0.64,1.2,2.9]
["Пром.","Хлеб ржаной",20,1.3,0.2,6.7,34.2,0.04,0.02,0,0,0,122,49,7,9.4,31.6,0.78,0,6.18,0]
[null,"Итого за Обед",{"$f":"SUM(C292:C299)","v":675},{"$f":"SUM(D292:D299)","v":22.770000000000003},25.16,76.84,{"$f":"SUM(G292:G299)","v":625.4},0.16,0.1,249.76,0.09,10.17,629.6899999999999,528.4300000000001,157.07000000000002,52.129999999999995,149.58,3.46,42.9,7.96,48.44]
[null,"Полдник"]
["Пром.","Сок яблочный",160,0.8,0.16,16.16,69.3,0.01,0.01,0,0,1.28,7.3,159.36,9.86,5.57,9.74,1.95,0,0,0]
["Пром.","Булочка \"Ярославская\" хлебзавод ",50,1.6,0.2,10.3,133,0.03,0.01,0,0,0,90.75,27.75,4.5,6.9,18.15,0.44,0,0,0]
[null,"Итого за Полдник",{"$f":"SUM(C302:C303)","v":210},{"$f":"SUM(D302:D303)","v":2.4000000000000004},0.36,26.46,{"$f":"SUM(G302:G303)","v":202.3},0.04,0.02,0,0,1.28,98.05,187.11,14.36,12.47,27.89,2.39,0,0,0]
[null,"Итого за день",{"$f":"C287+C290+C300+C304","v":1360},{"$f":"D287+D290+D300+D304","v":43.95},47.47,127.55000000000001,{"$f":"G287+G290+G300+G304","v":1197.2},0.33,0.7300000000000001,465.6,2.27,12.76,1156.05,1156.69,520.6500000000001,111.38,538.97,8.81,100.69999999999999,36.68,144.49]
[]
["12 день, 2 неделя"]
["№ рецептуры","Название блюда","Масса","Белки","Жиры","Углеводы","Энергетическая ценность","B1","B2","A","D","C","Na","K","Ca","Mg","P","Fe","I","Se","F"]
[null,null,"г","г","г","г","ккал","мг","мг","мкг рет.экв","мкг","мг","мг","мг","мг","мг","мг","мг","мкг","мкг","мкг"]
[null,"Суббота, 2 неделя"]
[null,"Завтрак","1-7"]
["54-1з-2020","Сыр твердых сортов в нарезке",10,2.3,3,0,35.8,0,0.03,26,0.1,0.07,81,8.8,88,3.5,50,0.1,0,1.45,0]
["54-21к-2020","Каша вязкая молочная ячневая",180,6.5,8.4,30.7,224.1,0.11,0.15,37.37,0.12,0.51,308,190.34,152.51,29.61,199.7,0.76,44.91,15.08,56.02]
["54-2гн-2020","Чай с сахаром",150,0.1,0,4.8,19.6,0,0,0.11,0,0.02,0.27,7.85,47.93,1.44,2.69,0.28,0,0,0]
["Пром.","Батон простой",20,1.6,0.2,9.8,47.5,0.03,0.01,0,0,0,88.6,27.2,4.6,6.8,17.8,0.4,0.64,1.2,2.9]
[null,"Итого за Завтрак",{"$f":"SUM(C312:C315)","v":360},{"$f":"SUM(D312:D315)","v":10.5},11.6,45.3,327,0.14,0.19,63.48,0.22,0.6000000000000001,477.87,234.19,293.04,41.349999999999994,270.19,1.54,45.55,17.73,58.92]
[null,"Второй завтрак"]
["Пром.","Молоко 2.5%",150,4.4,3.8,7.2,80,0.06,0.23,33,0,1.95,75,219,180,21,135,0.15,13.5,3,30]
[null,"Итого за Второй завтрак",150,4.4,3.8,7.2,80,0.06,0.23,33,0,1.95,75,219,180,21,135,0.15,13.5,3,30]
[null,"Обед"]
["54-11з-2020","Салат из моркови с яблоками и растительным маслом",50,0.46,5.09,3.57,62,0.01,0.02,366.45,0,2,57,86,10,11,16,0.5,8.5,0,17.98]
["54-6с-2020","Суп картофельный с клецками",200,4.6,3.3,11.4,93.6,0.05,0.04,101.43,0.05,3.69,58.01,222.12,13.28,12.74,35.97,0.54,10.28,0.94,21.22]
["54-21г-2020","Горошница",130,12.5,1.1,29.3,177.5,0.38,0.08,0.78,0,0,143.79,471.02,108.29,60.59,186.33,3.86,20.65,7.49,19.5]
["54-7р-2020","Рыба, припущенная в молоке (минтай)",75,9.8,5.8,2.1,100,0.06,0.08,6.77,0.12,0.84,82.98,260.04,51.16,33.5,151.85,0.55,100.11,8.88,429.45]
["54-33хн-2020","Напиток апельсиновый",150,0.1,0,6,24.8,0,0,0.79,0,3.96,1.67,27.11,55.85,1.87,3.3,0.06,0.33,0.07,2.81]
["Пром.","Хлеб ржаной",20,1.3,0.2,6.7,34.2,0.04,0.02,0,0,0,122,49,7,9.4,31.6,0.78,0,6.18,0]
[null,"Итого за Обед",{"$f":"SUM(C321:C326)","v":625},{"$f":"SUM(D321:D326)","v":28.76},{"$f":"SUM(E321:E326)","v":15.489999999999998},{"$f":"SUM(F321:F326)","v":59.07000000000001},{"$f":"SUM(G321:G326)","v":492.1},{"$f":"SUM(H321:H326)","v":0.54},{"$f":"SUM(I321:I326)","v":0.24000000000000002},{"$f":"SUM(J321:J326)","v":476.21999999999997},{"$f":"SUM(K321:K326)","v":0.16999999999999998},{"$f":"SUM(L321:L326)","v":10.489999999999998},{"$f":"SUM(M321:M326)","v":465.45},{"$f":"SUM(N321:N326)","v":1115.29},{"$f":"SUM(O321:O326)","v":245.57999999999998},{"$f":"SUM(P321:P326)","v":129.10000000000002},{"$f":"SUM(Q321:Q326)","v":425.05},{"$f":"SUM(R321:R326)","v":6.29},{"$f":"SUM(S321:S326)","v":139.87},{"$f":"SUM(T321:T326)","v":23.560000000000002},{"$f":"SUM(U321:U326)","v":490.96}]
[null,"Итого за день",{"$f":"C316+C319+C327","v":1135},{"$f":"D316+D319+D327","v":43.660000000000004},{"$f":"E316+E319+E327","v":30.889999999999997},{"$f":"F316+F319+F327","v":111.57000000000001},{"$f":"G316+G319+G327","v":899.1},{"$f":"H316+H319+H327","v":0.74},{"$f":"I316+I319+I327","v":0.66},{"$f":"J316+J319+J327","v":572.6999999999999},{"$f":"K316+K319+K327","v":0.39},{"$f":"L316+L319+L327","v":13.04},{"$f":"M316+M319+M327","v":1018.3199999999999},{"$f":"N316+N319+N327","v":1568.48},{"$f":"O316+O319+O327","v":718.62},{"$f":"P316+P319+P327","v":191.45000000000002},{"$f":"Q316+Q319+Q327","v":830.24},{"$f":"R316+R319+R327","v":7.98},{"$f":"S316+S319+S327","v":198.92000000000002},{"$f":"T316+T319+T327","v":44.290000000000006},{"$f":"U316+U319+U327","v":579.88}]
[]
[null,"ИТОГО","Пищевые вещества",null,null,"Энергетическая ценность","Витамины",{"$nulls":4},"Минеральные вещества"]
[null,null,"Белки","Жиры","Углеводы",null,"B1","B2","A","D","C","Na","K","Ca","Mg","P","Fe","I","Se","F"]
[null,null,"г","г","г","ккал","мг","мг","мкг рет.экв","мкг","мг","мг","мг","мг","мг","мг","мг","мкг","мкг","мкг"]
[null,"Итого за весь период",{"$f":"D33+D60+D88+D117+D144+D194+D221+D248+D277+D305+D328+D168","v":552.78},{"$f":"E33+E60+E88+E117+E144+E194+E221+E248+E277+E305+E328+E168","v":454.58},{"$f":"F33+F60+F88+F117+F144+F194+F221+F248+F277+F305+F328+F168","v":1754.85},{"$f":"G33+G60+G88+G117+G144+G194+G221+G248+G277+G305+G328+G168","v":13392.800000000001},{"$f":"H33+H60+H88+H117+H144+H194+H221+H248+H277+H305+H328+H168","v":6.15},{"$f":"I33+I60+I88+I117+I144+I194+I221+I248+I277+I305+I328+I168","v":8.400000000000002},{"$f":"J33+J60+J88+J117+J144+J194+J221+J248+J277+J305+J328+J168","v":4378.03},{"$f":"K33+K60+K88+K117+K144+K194+K221+K248+K277+K305+K328+K168","v":7.330000000000001},{"$f":"L33+L60+L88+L117+L144+L194+L221+L248+L277+L305+L328+L168","v":269.01},{"$f":"M33+M60+M88+M117+M144+M194+M221+M248+M277+M305+M328+M168","v":12925.109999999997},{"$f":"N33+N60+N88+N117+N144+N194+N221+N248+N277+N305+N328+N168","v":19132.48},{"$f":"O33+O60+O88+O117+O144+O194+O221+O248+O277+O305+O328+O168","v":7700.0999999999985},{"$f":"P33+P60+P88+P117+P144+P194+P221+P248+P277+P305+P328+P168","v":2110.66},{"$f":"Q33+Q60+Q88+Q117+Q144+Q194+Q221+Q248+Q277+Q305+Q328+Q168","v":8407.31},{"$f":"R33+R60+R88+R117+R144+R194+R221+R248+R277+R305+R328+R168","v":108.86000000000001},{"$f":"S33+S60+S88+S117+S144+S194+S221+S248+S277+S305+S328+S168","v":1451.5700000000002},{"$f":"T33+T60+T88+T117+T144+T194+T221+T248+T277+T305+T328+T168","v":383.74},{"$f":"U33+U60+U88+U117+U144+U194+U221+U248+U277+U305+U328+U168","v":2823.05}]
[null,"Среднее значение",{"$f":"C333/12","v":{"v":46.065,"d":"46.07"}},{"$f":"D333/12","v":{"v":37.88166666666667,"d":"37.88"}},146.23749999999998,1116.0666666666668,{"v":0.5125000000000001,"d":"0.51"},{"v":0.7000000000000002,"d":"0.70"},364.8358333333333,{"v":0.6108333333333335,"d":"0.61"},22.4175,1077.0924999999997,1594.3733333333332,641.6749999999998,175.88833333333332,700.6091666666666,{"v":9.071666666666667,"d":"9.07"},120.96416666666669,31.978333333333335,235.2541666666667]
[null,"Содержание белков, жиров, углеводов в меню за период в % от калорийности",{"$f":"C333*4/F333*100","v":{"v":16.50976644167015,"d":"16.51"}},{"$f":"D333*9/F333*100","v":{"v":30.547906337733703,"d":"30.55"}},52.94]
[]
[null,null,"СУММАРНЫЕ ОБЪЕМЫ БЛЮД ПО ПРИЕМАМ ПИЩИ (В ГРАММАХ)"]
[]
[null,"Возраст детей","завтрак",null,"второй завтрак",null,"обед",null,"полдник"]
[null,"1-7 лет",{"$f":"(C16+C44+C70+C99+C127+C178+C205+C231+C259+C287+C316+C154)/12","v":{"v":347.9166666666667,"d":"348"}},null,{"$f":"(C19+C47+C73+C102+C130+C181+C208+C234+C262+C290+C319+C157)/12","v":{"v":152.5,"d":"153"}},null,{"$f":"(C27+C55+C83+C111+C139+C189+C216+C243+C271+C300+C327+C165)/12","v":{"v":631.6666666666666,"d":"632"}},null,{"$f":"(C32+C59+C87+C116+C143+C193+C220+C247+C276+C304)/10","v":{"v":224.5,"d":"225"}}]